Quality Oriented for Physical Design Data Warehouse
نویسندگان
چکیده
To construct a data warehouse (DW) as a collection of data marts (DMs) all at once in a single project is very difficult. There is a need to determine the first DM that should be constructed. After two or more DMs are constructed, the next problem is integrating all DMs into the enterprise DW. This paper is adaptation of bus matrix, quality function deployment (QFD) matrix, political factors and DM integration technique to be a single framework in order to determine the priority of DMs that should be constructed and how to integrate the entire DMs into the enterprise DW.
منابع مشابه
Uclean: a Requirement Based Object- Oriented Etl Framework
Data warehouse is used to provide effective results from multidimensional data analysis. The accuracy and correctness of these results depend on the quality of the data. To improve data quality, data must be properly extracted, transformed and loaded into the data warehouse. This ETL process is the key to the success of a data warehouse. In this paper we propose a conceptual ETL framework for a...
متن کاملQuality Oriented Logical Design for Data Warehouse Development
To make an effective data warehouse logical design which is related to system performance, it is important to manage an appropriate methodology for data fragmentation, indexing and materialized view. Executing a query in a data warehouse may take hours or days to run without the proper optimization technique. This paper proposed a framework on integrating quality, deliverables in conceptual des...
متن کاملUML for data warehouse dimensional modeling
Dimensional modeling is a common modeling technique in data warehousing. It reflects a simple logical view of a data warehouse system. It can be easily mapped to a physical design. Traditional dimensional modeling is data-oriented and semantically informal. From a software engineering perspective, the informal notations and data-oriented feature are insufficient to tackle the complexity of larg...
متن کاملAdding a Performance-Oriented Perspective to Data Warehouse Design
Data warehouse design is clearly dominated by the business perspective. Quite often, data warehouse administrators are lead to data models with little room for performance improvement. However, the increasing demands for interactive response time from the users make query performance one of the central problems of data warehousing today. In this paper we defend that data warehouse design must t...
متن کاملImproving the Data Warehouse Architecture Using Design Patterns
Data warehousing is an important part of the enterprise information system. Business intelligence (BI) relies on data warehouses to improve business performance. Data quality plays a key role in BI. Source data is extracted, transformed, and loaded (ETL) into the data warehouses periodically. The ETL operations have the most crucial impact on the data quality of the data warehouse. ETL-related ...
متن کامل